{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'GetEdgarFilingListResult': [{'DocumentList': [{'CreateDate': '/Date(1509710920957-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 4014860,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1509710920957-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 4014861,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1509710920957-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 4014862,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/b57389e6-9721-4ca7-ab0d-8fb9767a1d43.rtf'},\n",
       "    {'CreateDate': '/Date(1509710920957-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 4014863,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/ca6735cd-5ab7-4bb9-abf8-564739c3506b.pdf'},\n",
       "    {'CreateDate': '/Date(1509710920957-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 4014864,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1509710920957-0500)/',\n",
       "     'DocumentType': 'XBRL',\n",
       "     'FilingDocumentId': 4014865,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/038fb010-43b3-4e2d-b583-cb9d2d059fe5.zip'},\n",
       "    {'CreateDate': '/Date(1509710920957-0500)/',\n",
       "     'DocumentType': 'XBRL_HTML',\n",
       "     'FilingDocumentId': 4014866,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/bc9269c5-539b-4a69-9054-abe7849c4242.html'},\n",
       "    {'CreateDate': '/Date(1509710920957-0500)/',\n",
       "     'DocumentType': 'REDLINE',\n",
       "     'FilingDocumentId': 4014867,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1509710920957-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 4014868,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/500ba946-098f-4f5c-a439-9d5e17edb995.xls'}],\n",
       "   'EdgarFilingId': 1304204,\n",
       "   'FilingAgentId': 2035,\n",
       "   'FilingAgentName': 'APPLE INC',\n",
       "   'FilingDate': '11/03/2017 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 12357861,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=12357861',\n",
       "   'ReceivedDate': '11/03/2017 07:04:35',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1477514833067-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 3333565,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1477514833067-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 3333566,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1477514833067-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 3333567,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/7e96cb6d-31c1-4caa-8e5b-dc11ed635e67.rtf'},\n",
       "    {'CreateDate': '/Date(1477514833067-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 3333568,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/ffb58afc-aa5d-4b55-8d12-8e0937575a35.pdf'},\n",
       "    {'CreateDate': '/Date(1477514833067-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 3333569,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1477514833067-0500)/',\n",
       "     'DocumentType': 'XBRL',\n",
       "     'FilingDocumentId': 3333570,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/9ec9b730-3d06-4ce0-94c0-1b5cb42a2ea6.zip'},\n",
       "    {'CreateDate': '/Date(1477514833067-0500)/',\n",
       "     'DocumentType': 'XBRL_HTML',\n",
       "     'FilingDocumentId': 3333571,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/33c267b6-ed2e-4b1b-bf80-4db710683a2a.html'},\n",
       "    {'CreateDate': '/Date(1477514833067-0500)/',\n",
       "     'DocumentType': 'REDLINE',\n",
       "     'FilingDocumentId': 3333572,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1477514833067-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 3333573,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/2f18687b-4bc5-4f21-acab-2d7f7b52412d.xls'}],\n",
       "   'EdgarFilingId': 1113331,\n",
       "   'FilingAgentId': 953736,\n",
       "   'FilingAgentName': 'WORKIVA INC. WDESK FA01',\n",
       "   'FilingDate': '10/26/2016 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 11649684,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=11649684',\n",
       "   'ReceivedDate': '10/26/2016 15:45:28',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1446065204790-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 1309241,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1446065204790-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 1309242,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1446065204790-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 1309243,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/ef0b9544-a528-4725-a8e2-bfe4da43a147.rtf'},\n",
       "    {'CreateDate': '/Date(1446065204790-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 1309244,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/fae19475-b538-441b-ab15-0a311f161ebb.pdf'},\n",
       "    {'CreateDate': '/Date(1446065204790-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 1309245,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1446065204790-0500)/',\n",
       "     'DocumentType': 'XBRL',\n",
       "     'FilingDocumentId': 1309246,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/944bf4e5-ef90-4b01-a129-fa5154ad68c3.zip'},\n",
       "    {'CreateDate': '/Date(1446065204790-0500)/',\n",
       "     'DocumentType': 'XBRL_HTML',\n",
       "     'FilingDocumentId': 1309247,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/fe78b92c-786a-4204-8b9d-dbc3c03c4872.html'},\n",
       "    {'CreateDate': '/Date(1446065204790-0500)/',\n",
       "     'DocumentType': 'REDLINE',\n",
       "     'FilingDocumentId': 1309248,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1446065204790-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 1309249,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/a95f57d7-802e-4ab1-b9aa-41e46414ab95.xls'}],\n",
       "   'EdgarFilingId': 743100,\n",
       "   'FilingAgentId': 403099,\n",
       "   'FilingAgentName': 'RR DONNELLEY /FA/',\n",
       "   'FilingDate': '10/28/2015 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 10973752,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=10973752',\n",
       "   'ReceivedDate': '10/28/2015 15:35:18',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228527160-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 980171,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228527160-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 980172,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228527160-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 980173,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/7cdcbb6f-6d93-4919-8c83-a0babcbd29b1.rtf'},\n",
       "    {'CreateDate': '/Date(1427228527160-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 980174,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/61236a14-a4e7-4bb2-8130-ddc2c66c9678.pdf'},\n",
       "    {'CreateDate': '/Date(1427228527160-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 980175,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228527160-0500)/',\n",
       "     'DocumentType': 'XBRL',\n",
       "     'FilingDocumentId': 980176,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/c8fcf5a4-77a5-4654-bfe3-7b4e5dbb8d5b.zip'},\n",
       "    {'CreateDate': '/Date(1427228527160-0500)/',\n",
       "     'DocumentType': 'XBRL_HTML',\n",
       "     'FilingDocumentId': 980177,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/e1eac374-d935-4007-bad9-32f6577ff8e6.html'},\n",
       "    {'CreateDate': '/Date(1427228527160-0500)/',\n",
       "     'DocumentType': 'REDLINE',\n",
       "     'FilingDocumentId': 980178,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228527160-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 980179,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/59c6c239-6807-462b-9a44-e0fa1f69eb9c.xls'}],\n",
       "   'EdgarFilingId': 683515,\n",
       "   'FilingAgentId': 403099,\n",
       "   'FilingAgentName': 'RR DONNELLEY /FA/',\n",
       "   'FilingDate': '10/27/2014 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 10264100,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=10264100',\n",
       "   'ReceivedDate': '10/27/2014 16:12:42',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228532027-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 980824,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228532027-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 980825,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228532027-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 980826,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/d0db14cb-9827-4a96-b06f-f077305b21d3.rtf'},\n",
       "    {'CreateDate': '/Date(1427228532027-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 980827,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/e3115d1d-4246-45ae-94f2-f8e3762d8e3e.pdf'},\n",
       "    {'CreateDate': '/Date(1427228532027-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 980828,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228532027-0500)/',\n",
       "     'DocumentType': 'XBRL',\n",
       "     'FilingDocumentId': 980829,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/c3db074a-50de-43a6-9dc1-f8f1c52cf6f6.zip'},\n",
       "    {'CreateDate': '/Date(1427228532027-0500)/',\n",
       "     'DocumentType': 'XBRL_HTML',\n",
       "     'FilingDocumentId': 980830,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/51e501dc-5d04-4a33-a559-574270b3903a.html'},\n",
       "    {'CreateDate': '/Date(1427228532027-0500)/',\n",
       "     'DocumentType': 'REDLINE',\n",
       "     'FilingDocumentId': 980831,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228532027-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 980832,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/7d253009-be75-4045-8d9b-451ad814da1f.xls'}],\n",
       "   'EdgarFilingId': 683624,\n",
       "   'FilingAgentId': 403099,\n",
       "   'FilingAgentName': 'RR DONNELLEY /FA/',\n",
       "   'FilingDate': '10/30/2013 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 9575604,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=9575604',\n",
       "   'ReceivedDate': '10/30/2013 05:01:55',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228536100-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 981398,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228536100-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 981399,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228536100-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 981400,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/6142173c-1261-4bd7-a766-645cf3940a1f.rtf'},\n",
       "    {'CreateDate': '/Date(1427228536100-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 981401,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/da2b9499-7462-4333-bc37-75212f65699e.pdf'},\n",
       "    {'CreateDate': '/Date(1427228536100-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 981402,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228536100-0500)/',\n",
       "     'DocumentType': 'XBRL',\n",
       "     'FilingDocumentId': 981403,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/c649c977-4665-428c-8b32-354d3385beb3.zip'},\n",
       "    {'CreateDate': '/Date(1427228536100-0500)/',\n",
       "     'DocumentType': 'XBRL_HTML',\n",
       "     'FilingDocumentId': 981404,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/3bcec30a-187c-46b3-a9e5-fe2310c5dcf0.html'},\n",
       "    {'CreateDate': '/Date(1427228536100-0500)/',\n",
       "     'DocumentType': 'REDLINE',\n",
       "     'FilingDocumentId': 981405,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228536100-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 981406,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/251de549-54b5-42b3-9a63-f9af2fb3d801.xls'}],\n",
       "   'EdgarFilingId': 683718,\n",
       "   'FilingAgentId': 403099,\n",
       "   'FilingAgentName': 'RR DONNELLEY /FA/',\n",
       "   'FilingDate': '10/31/2012 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 8888271,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=8888271',\n",
       "   'ReceivedDate': '10/31/2012 16:08:04',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228540017-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 981949,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228540017-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 981950,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228540017-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 981951,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/4a1ba0ae-6838-43a5-aada-31459f36ef1d.rtf'},\n",
       "    {'CreateDate': '/Date(1427228540017-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 981952,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/64c7905f-0468-48d9-8f25-e6ec8f3b5e32.pdf'},\n",
       "    {'CreateDate': '/Date(1427228540017-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 981953,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228540017-0500)/',\n",
       "     'DocumentType': 'XBRL',\n",
       "     'FilingDocumentId': 981954,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/79c01783-bef9-4fbb-a4eb-85e948760c64.zip'},\n",
       "    {'CreateDate': '/Date(1427228540017-0500)/',\n",
       "     'DocumentType': 'XBRL_HTML',\n",
       "     'FilingDocumentId': 981955,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/3354eca0-2917-4d34-b34f-0538174b00f4.html'},\n",
       "    {'CreateDate': '/Date(1427228540017-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 981956,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/5d2d8b92-e80a-42b5-b1d7-c3e84b66579e.xls'}],\n",
       "   'EdgarFilingId': 683809,\n",
       "   'FilingAgentId': 403099,\n",
       "   'FilingAgentName': 'RR DONNELLEY /FA/',\n",
       "   'FilingDate': '10/26/2011 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 8204587,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=8204587',\n",
       "   'ReceivedDate': '10/26/2011 15:36:24',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228543933-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 982488,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228543933-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 982489,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228543933-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 982490,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/4066b2cf-b19c-4a33-90bb-aa712093284b.rtf'},\n",
       "    {'CreateDate': '/Date(1427228543933-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 982491,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/afa23a45-2381-49cc-9933-750c74d3f0a8.pdf'},\n",
       "    {'CreateDate': '/Date(1427228543933-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 982492,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228543933-0500)/',\n",
       "     'DocumentType': 'XBRL',\n",
       "     'FilingDocumentId': 982493,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/34b5cd5d-641e-47b2-977d-f853cfa84f6b.zip'},\n",
       "    {'CreateDate': '/Date(1427228543933-0500)/',\n",
       "     'DocumentType': 'XBRL_HTML',\n",
       "     'FilingDocumentId': 982494,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/6fdf7e26-15fd-4f24-b8d0-a3ddf15f8882.html'},\n",
       "    {'CreateDate': '/Date(1427228543933-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 982495,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/759f7c57-5d45-4920-b614-7935cf4af2ce.xls'}],\n",
       "   'EdgarFilingId': 683898,\n",
       "   'FilingAgentId': 403099,\n",
       "   'FilingAgentName': 'RR DONNELLEY /FA/',\n",
       "   'FilingDate': '10/27/2010 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 7519151,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=7519151',\n",
       "   'ReceivedDate': '10/27/2010 15:37:12',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228546943-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 982894,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228546943-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 982895,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228546943-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 982896,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/b1abb55b-58dc-47a0-aa98-20f585fb791b.rtf'},\n",
       "    {'CreateDate': '/Date(1427228546943-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 982897,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/26718335-ad40-4412-8851-39f33010aa52.pdf'},\n",
       "    {'CreateDate': '/Date(1427228546943-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 982898,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228546943-0500)/',\n",
       "     'DocumentType': 'XBRL',\n",
       "     'FilingDocumentId': 982899,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/36cfb756-20d7-46cf-b42b-c99ca0cdf8cb.zip'},\n",
       "    {'CreateDate': '/Date(1427228546943-0500)/',\n",
       "     'DocumentType': 'XBRL_HTML',\n",
       "     'FilingDocumentId': 982900,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/9c4b9493-4d44-432e-9cab-4af2a12a55a8.html'},\n",
       "    {'CreateDate': '/Date(1427228546943-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 982901,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/107a27b0-f18c-4534-a2db-8e1a04116afc.xls'}],\n",
       "   'EdgarFilingId': 683965,\n",
       "   'FilingAgentId': 403099,\n",
       "   'FilingAgentName': 'RR DONNELLEY /FA/',\n",
       "   'FilingDate': '01/25/2010 00:00:00',\n",
       "   'FilingDescription': 'Amended Annual Report',\n",
       "   'FilingId': 7001526,\n",
       "   'FilingTypeId': 8,\n",
       "   'FilingTypeMnemonic': '10-K/A',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=7001526',\n",
       "   'ReceivedDate': '01/25/2010 15:26:45',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228547253-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 982958,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228547253-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 982959,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228547253-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 982960,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/0c8aa9b9-ad2a-4010-ba16-c03978a9b14e.rtf'},\n",
       "    {'CreateDate': '/Date(1427228547253-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 982961,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/5dfc8604-cbdc-448b-ba04-700a22a37909.pdf'},\n",
       "    {'CreateDate': '/Date(1427228547253-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 982962,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228547253-0500)/',\n",
       "     'DocumentType': 'XBRL',\n",
       "     'FilingDocumentId': 982963,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/482ef536-08a8-4603-9077-273c1dde3600.zip'},\n",
       "    {'CreateDate': '/Date(1427228547253-0500)/',\n",
       "     'DocumentType': 'XBRL_HTML',\n",
       "     'FilingDocumentId': 982964,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/26c5c055-a754-45f4-a873-1125a133f628.html'},\n",
       "    {'CreateDate': '/Date(1427228547253-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 982965,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/5be152a9-9309-4ae8-aee9-c248e40f5dd3.xls'}],\n",
       "   'EdgarFilingId': 683975,\n",
       "   'FilingAgentId': 403099,\n",
       "   'FilingAgentName': 'RR DONNELLEY /FA/',\n",
       "   'FilingDate': '10/27/2009 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 6855302,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=6855302',\n",
       "   'ReceivedDate': '10/27/2009 15:18:59',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228550093-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 983327,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228550093-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 983328,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228550093-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 983329,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/b4b968e7-25cb-4df8-b48b-c1c7ead723e2.rtf'},\n",
       "    {'CreateDate': '/Date(1427228550093-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 983330,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/f4e66939-3f5e-4751-8206-ae4c372faf6b.pdf'},\n",
       "    {'CreateDate': '/Date(1427228550093-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 983331,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228550093-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 983332,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/d395a8f5-c916-4c1e-a403-9114cc873db6.xls'}],\n",
       "   'EdgarFilingId': 684037,\n",
       "   'FilingAgentId': 403099,\n",
       "   'FilingAgentName': 'RR DONNELLEY /FA/',\n",
       "   'FilingDate': '11/05/2008 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 6227652,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=6227652',\n",
       "   'ReceivedDate': '11/05/2008 05:16:47',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228553603-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 983811,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228553603-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 983812,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228553603-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 983813,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/3bd4bba4-3284-47b0-924d-0b59d3ebfd33.rtf'},\n",
       "    {'CreateDate': '/Date(1427228553603-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 983814,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/4913a187-8e3a-418a-a499-b210aebd9da6.pdf'},\n",
       "    {'CreateDate': '/Date(1427228553603-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 983815,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228553603-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 983816,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/e3eeaecf-7d97-4bca-84e7-f4c3676ea4c6.xls'}],\n",
       "   'EdgarFilingId': 684118,\n",
       "   'FilingAgentId': 93314,\n",
       "   'FilingAgentName': 'MERRILL CORP /NEW/ - FA',\n",
       "   'FilingDate': '11/15/2007 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 5548885,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=5548885',\n",
       "   'ReceivedDate': '11/15/2007 15:50:11',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228555880-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 984126,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228555880-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 984127,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228555880-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 984128,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/f8e8027c-c493-46b2-b5e8-e199d7636fc5.rtf'},\n",
       "    {'CreateDate': '/Date(1427228555880-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 984129,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/fe62c184-ea73-48b6-8dab-7bb78eeff113.pdf'},\n",
       "    {'CreateDate': '/Date(1427228555880-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 984130,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228555880-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 984131,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/632348a7-f04a-43c7-b229-f97a9dc1636d.xls'}],\n",
       "   'EdgarFilingId': 684171,\n",
       "   'FilingAgentId': 93513,\n",
       "   'FilingAgentName': 'MERRILL CORP-MD/FA',\n",
       "   'FilingDate': '12/29/2006 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 4848001,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=4848001',\n",
       "   'ReceivedDate': '12/29/2006 05:06:47',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228555977-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 984138,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228555977-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 984139,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228555977-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 984140,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/e288d61e-0576-4db7-82ec-94f77f1c3efa.rtf'},\n",
       "    {'CreateDate': '/Date(1427228555977-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 984141,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/6d126872-dcd7-477c-9be6-53f6cf853a3b.pdf'},\n",
       "    {'CreateDate': '/Date(1427228555977-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 984142,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228555977-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 984143,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/509bb2a3-c73d-4fd2-9069-1567fe0fca98.xls'}],\n",
       "   'EdgarFilingId': 684173,\n",
       "   'FilingAgentId': 93513,\n",
       "   'FilingAgentName': 'MERRILL CORP-MD/FA',\n",
       "   'FilingDate': '12/15/2006 00:00:00',\n",
       "   'FilingDescription': 'Notification that Annual Report will be submitted late',\n",
       "   'FilingId': 4825259,\n",
       "   'FilingTypeId': 258,\n",
       "   'FilingTypeMnemonic': 'NT 10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=4825259',\n",
       "   'ReceivedDate': '12/15/2006 05:03:03',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228560560-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 984735,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228560560-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 984736,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228560560-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 984737,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/14bcdc51-fe76-4cb8-9250-9ebf067341d1.rtf'},\n",
       "    {'CreateDate': '/Date(1427228560560-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 984738,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/8857f118-4943-4198-8089-38d74a8b6646.pdf'},\n",
       "    {'CreateDate': '/Date(1427228560560-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 984739,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228560560-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 984740,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/34087a0a-a75a-4db6-b460-7041bd1637fb.xls'}],\n",
       "   'EdgarFilingId': 684273,\n",
       "   'FilingAgentId': 93513,\n",
       "   'FilingAgentName': 'MERRILL CORP-MD/FA',\n",
       "   'FilingDate': '12/01/2005 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 4047854,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=4047854',\n",
       "   'ReceivedDate': '12/01/2005 05:05:55',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228565257-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 985373,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228565257-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 985374,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228565257-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 985375,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/1d306cd4-b809-438b-ad83-fbed8dd91399.rtf'},\n",
       "    {'CreateDate': '/Date(1427228565257-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 985376,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/b0b7d71b-26ce-46b6-a84d-30b07944baa9.pdf'},\n",
       "    {'CreateDate': '/Date(1427228565257-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 985377,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228565257-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 985378,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/3667ce69-03a2-46fa-85af-4164f8b8695e.xls'}],\n",
       "   'EdgarFilingId': 684380,\n",
       "   'FilingAgentId': 93314,\n",
       "   'FilingAgentName': 'MERRILL CORP /NEW/ - FA',\n",
       "   'FilingDate': '12/03/2004 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 3320468,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=3320468',\n",
       "   'ReceivedDate': '12/03/2004 05:02:38',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228570140-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 985964,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228570140-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 985965,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228570140-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 985966,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/d597eeac-4ac3-470a-8561-660448c5381c.rtf'},\n",
       "    {'CreateDate': '/Date(1427228570140-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 985967,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/44de2deb-4f57-4db8-a66f-8db6f2bad157.pdf'},\n",
       "    {'CreateDate': '/Date(1427228570140-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 985968,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228570140-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 985969,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/8fe52725-60be-4281-969e-25379d352a9a.xls'}],\n",
       "   'EdgarFilingId': 684479,\n",
       "   'FilingAgentId': 93314,\n",
       "   'FilingAgentName': 'MERRILL CORP /NEW/ - FA',\n",
       "   'FilingDate': '12/19/2003 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 2654052,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=2654052',\n",
       "   'ReceivedDate': '12/19/2003 16:28:51',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228571060-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 986095,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228571060-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 986096,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228571060-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 986097,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/92d2296c-c292-4219-8d59-79026e328b70.rtf'},\n",
       "    {'CreateDate': '/Date(1427228571060-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 986098,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/adb74179-eb49-4034-9440-be75f98941fb.pdf'},\n",
       "    {'CreateDate': '/Date(1427228571060-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 986099,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228571060-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 986100,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/8dd1907a-65a2-41af-b82e-38121c01879f.xls'}],\n",
       "   'EdgarFilingId': 684502,\n",
       "   'FilingAgentId': 93314,\n",
       "   'FilingAgentName': 'MERRILL CORP /NEW/ - FA',\n",
       "   'FilingDate': '12/19/2002 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 2091397,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=2091397',\n",
       "   'ReceivedDate': '12/19/2002 16:24:57',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228571670-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 986170,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228571670-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 986171,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228571670-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 986172,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/7bb24a8d-d35e-4447-9a76-9426f9217e8a.rtf'},\n",
       "    {'CreateDate': '/Date(1427228571670-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 986173,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/3433bd1c-a159-46c1-aaed-aa2c343cf56b.pdf'},\n",
       "    {'CreateDate': '/Date(1427228571670-0500)/',\n",
       "     'DocumentType': 'CONVTEXT',\n",
       "     'FilingDocumentId': 986174,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228571670-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 986175,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/1df69d90-abe5-4684-8327-82655b39990e.xls'}],\n",
       "   'EdgarFilingId': 684517,\n",
       "   'FilingAgentId': 92627,\n",
       "   'FilingAgentName': 'MERRILL CORP /FA/',\n",
       "   'FilingDate': '12/21/2001 00:00:00',\n",
       "   'FilingDescription': 'Annual Report (Regulation S-K, item 405)',\n",
       "   'FilingId': 1713303,\n",
       "   'FilingTypeId': 9,\n",
       "   'FilingTypeMnemonic': '10-K405',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=1713303',\n",
       "   'ReceivedDate': '12/21/2001 15:42:38',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228572217-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 986230,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228572217-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 986231,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228572217-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 986232,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/ecd1c0df-53d3-41b7-a575-72eb67c732d6.rtf'},\n",
       "    {'CreateDate': '/Date(1427228572217-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 986233,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/fe679759-28ea-4242-a079-5acbe17ef360.pdf'},\n",
       "    {'CreateDate': '/Date(1427228572217-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 986234,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/460a3cf4-1b95-491f-97ab-46063fac7b29.xls'}],\n",
       "   'EdgarFilingId': 684530,\n",
       "   'FilingAgentId': 92627,\n",
       "   'FilingAgentName': 'MERRILL CORP /FA/',\n",
       "   'FilingDate': '12/14/2000 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 374034,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=374034',\n",
       "   'ReceivedDate': '12/14/2000 16:18:50',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228572793-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 986295,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228572793-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 986296,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228572793-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 986297,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/c7d158d3-7c71-4fb0-9697-dd56aa2e734a.rtf'},\n",
       "    {'CreateDate': '/Date(1427228572793-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 986298,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/a5bc2fa9-0c1f-4ea1-8ba7-7c0cedbd5482.pdf'},\n",
       "    {'CreateDate': '/Date(1427228572793-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 986299,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/c6b1e70d-99ae-4384-be81-e8b1757820f6.xls'}],\n",
       "   'EdgarFilingId': 684544,\n",
       "   'FilingAgentId': 92627,\n",
       "   'FilingAgentName': 'MERRILL CORP /FA/',\n",
       "   'FilingDate': '12/22/1999 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 124179,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=124179',\n",
       "   'ReceivedDate': '12/22/1999 07:06:10',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228573417-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 986374,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228573417-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 986375,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228573417-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 986376,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/5280ddcb-813c-4783-a4ab-b2c850bd1300.rtf'},\n",
       "    {'CreateDate': '/Date(1427228573417-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 986377,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/19cdeb31-2f1d-4fcb-a4a5-cdef6954f12e.pdf'},\n",
       "    {'CreateDate': '/Date(1427228573417-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 986378,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/72f55332-53e3-4cfc-8a6c-f814cdff769c.xls'}],\n",
       "   'EdgarFilingId': 684560,\n",
       "   'FilingAgentId': 93314,\n",
       "   'FilingAgentName': 'MERRILL CORP /NEW/ - FA',\n",
       "   'FilingDate': '12/23/1998 00:00:00',\n",
       "   'FilingDescription': 'Annual Report (Regulation S-K, item 405)',\n",
       "   'FilingId': 107083,\n",
       "   'FilingTypeId': 9,\n",
       "   'FilingTypeMnemonic': '10-K405',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=107083',\n",
       "   'ReceivedDate': '12/23/1998 15:24:17',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228573743-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 986407,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228573743-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 986408,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228573743-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 986409,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/70f65746-340f-4cf6-b801-b51259c63511.rtf'},\n",
       "    {'CreateDate': '/Date(1427228573743-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 986410,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/301006af-4b67-47f0-858b-a82b27209b7c.pdf'},\n",
       "    {'CreateDate': '/Date(1427228573743-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 986411,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/361355d5-3cd4-4aba-a72e-ac0bb5c867f5.xls'}],\n",
       "   'EdgarFilingId': 684567,\n",
       "   'FilingAgentId': 93314,\n",
       "   'FilingAgentName': 'MERRILL CORP /NEW/ - FA',\n",
       "   'FilingDate': '01/23/1998 00:00:00',\n",
       "   'FilingDescription': 'Amended Annual Report',\n",
       "   'FilingId': 838425,\n",
       "   'FilingTypeId': 8,\n",
       "   'FilingTypeMnemonic': '10-K/A',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=838425',\n",
       "   'ReceivedDate': '01/23/1998 06:58:44',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228573947-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 986432,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228573947-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 986433,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228573947-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 986434,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/e289870f-9c89-4b1f-9d7f-98c8eeb4b2ea.rtf'},\n",
       "    {'CreateDate': '/Date(1427228573947-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 986435,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/ec25251c-ff17-4f63-85f6-9ff88947e797.pdf'},\n",
       "    {'CreateDate': '/Date(1427228573947-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 986436,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/05f33405-0995-465d-9e1d-9fb882bb5124.xls'}],\n",
       "   'EdgarFilingId': 684572,\n",
       "   'FilingAgentId': 93314,\n",
       "   'FilingAgentName': 'MERRILL CORP /NEW/ - FA',\n",
       "   'FilingDate': '12/05/1997 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 1202150,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=1202150',\n",
       "   'ReceivedDate': '12/05/1997 16:04:53',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228575227-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 986576,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228575227-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 986577,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228575227-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 986578,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/d049d9b0-08a0-437c-ba1d-0e1fb45a76d2.rtf'},\n",
       "    {'CreateDate': '/Date(1427228575227-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 986579,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/4e62e8f8-f9b6-4593-ad38-2ec2917d1b06.pdf'},\n",
       "    {'CreateDate': '/Date(1427228575227-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 986580,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/84aeafa1-d6c5-4e65-af65-27be64376e5f.xls'}],\n",
       "   'EdgarFilingId': 684602,\n",
       "   'FilingAgentId': 2035,\n",
       "   'FilingAgentName': 'APPLE INC',\n",
       "   'FilingDate': '12/19/1996 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 1061128,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=1061128',\n",
       "   'ReceivedDate': '12/18/1996 23:00:00',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228575633-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 986641,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228575633-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 986642,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228575633-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 986643,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/b6d5df91-fc2e-4f5b-8f80-1fa952da61ec.rtf'},\n",
       "    {'CreateDate': '/Date(1427228575633-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 986644,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/b7a94a0c-35c4-49a6-991e-3ad6d9a6447b.pdf'},\n",
       "    {'CreateDate': '/Date(1427228575633-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 986645,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/34ce5a39-8f68-4c27-89c6-96ccd6f9fee8.xls'}],\n",
       "   'EdgarFilingId': 684615,\n",
       "   'FilingAgentId': 2035,\n",
       "   'FilingAgentName': 'APPLE INC',\n",
       "   'FilingDate': '12/19/1995 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 418146,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=418146',\n",
       "   'ReceivedDate': '12/18/1995 23:00:00',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'},\n",
       "  {'DocumentList': [{'CreateDate': '/Date(1427228576380-0500)/',\n",
       "     'DocumentType': 'ORIG',\n",
       "     'FilingDocumentId': 986724,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228576380-0500)/',\n",
       "     'DocumentType': 'HTML',\n",
       "     'FilingDocumentId': 986725,\n",
       "     'Url': ''},\n",
       "    {'CreateDate': '/Date(1427228576380-0500)/',\n",
       "     'DocumentType': 'RTF',\n",
       "     'FilingDocumentId': 986726,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/1cb49008-e668-47c5-ba9f-4e55cd161d43.rtf'},\n",
       "    {'CreateDate': '/Date(1427228576380-0500)/',\n",
       "     'DocumentType': 'CONVPDF',\n",
       "     'FilingDocumentId': 986727,\n",
       "     'Url': 'http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/fd888e8d-be84-426d-81aa-01475d6c36b4.pdf'},\n",
       "    {'CreateDate': '/Date(1427228576380-0500)/',\n",
       "     'DocumentType': 'XLS',\n",
       "     'FilingDocumentId': 986728,\n",
       "     'Url': 'http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/0f83e3d6-e02c-4fbe-b806-8b10507695fd.xls'}],\n",
       "   'EdgarFilingId': 684632,\n",
       "   'FilingAgentId': 2035,\n",
       "   'FilingAgentName': 'APPLE INC',\n",
       "   'FilingDate': '12/13/1994 00:00:00',\n",
       "   'FilingDescription': 'Annual Report',\n",
       "   'FilingId': 280212,\n",
       "   'FilingTypeId': 7,\n",
       "   'FilingTypeMnemonic': '10-K',\n",
       "   'LinkToDetailPage': '/investor-relations/sec-filings/sec-filings-details/default.aspx?FilingId=280212',\n",
       "   'ReceivedDate': '12/12/1994 23:00:00',\n",
       "   'ReportPersonId': None,\n",
       "   'ReportPersonName': None,\n",
       "   'StockExchange': 'CIK',\n",
       "   'StockSymbol': '0000320193'}]}"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 获取年报文件\n",
    "import requests\n",
    "url = 'http://investor.apple.com/feed/SECFiling.svc/GetEdgarFilingList?apiKey=BF185719B0464B3CB809D23926182246&exchange=CIK&symbol=0000320193&formGroupIdList=1%2C4&excludeNoDocuments=true&pageSize=-1&pageNumber=0&tagList=&includeTags=true&year=-1&excludeSelection=1'\n",
    "rsp = requests.get(url)\n",
    "data = rsp.json()\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2017 http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/500ba946-098f-4f5c-a439-9d5e17edb995.xls\n",
      "2016 http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/2f18687b-4bc5-4f21-acab-2d7f7b52412d.xls\n",
      "2015 http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/a95f57d7-802e-4ab1-b9aa-41e46414ab95.xls\n",
      "2014 http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/59c6c239-6807-462b-9a44-e0fa1f69eb9c.xls\n",
      "2013 http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/7d253009-be75-4045-8d9b-451ad814da1f.xls\n",
      "2012 http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/251de549-54b5-42b3-9a63-f9af2fb3d801.xls\n",
      "2011 http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/5d2d8b92-e80a-42b5-b1d7-c3e84b66579e.xls\n",
      "2010 http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/759f7c57-5d45-4920-b614-7935cf4af2ce.xls\n",
      "2010 http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/107a27b0-f18c-4534-a2db-8e1a04116afc.xls\n",
      "2009 http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/5be152a9-9309-4ae8-aee9-c248e40f5dd3.xls\n",
      "2008 http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/d395a8f5-c916-4c1e-a403-9114cc873db6.xls\n",
      "2007 http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/e3eeaecf-7d97-4bca-84e7-f4c3676ea4c6.xls\n",
      "2006 http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/632348a7-f04a-43c7-b229-f97a9dc1636d.xls\n",
      "2006 http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/509bb2a3-c73d-4fd2-9069-1567fe0fca98.xls\n",
      "2005 http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/34087a0a-a75a-4db6-b460-7041bd1637fb.xls\n",
      "2004 http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/3667ce69-03a2-46fa-85af-4164f8b8695e.xls\n",
      "2003 http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/8fe52725-60be-4281-969e-25379d352a9a.xls\n",
      "2002 http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/8dd1907a-65a2-41af-b82e-38121c01879f.xls\n",
      "2001 http://d1lge852tjjqow.cloudfront.net/CIK-0000320193/1df69d90-abe5-4684-8327-82655b39990e.xls\n",
      "2000 http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/460a3cf4-1b95-491f-97ab-46063fac7b29.xls\n",
      "1999 http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/c6b1e70d-99ae-4384-be81-e8b1757820f6.xls\n",
      "1998 http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/72f55332-53e3-4cfc-8a6c-f814cdff769c.xls\n",
      "1998 http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/361355d5-3cd4-4aba-a72e-ac0bb5c867f5.xls\n",
      "1997 http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/05f33405-0995-465d-9e1d-9fb882bb5124.xls\n",
      "1996 http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/84aeafa1-d6c5-4e65-af65-27be64376e5f.xls\n",
      "1995 http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/34ce5a39-8f68-4c27-89c6-96ccd6f9fee8.xls\n",
      "1994 http://d18rn0p25nwr6d.cloudfront.net/CIK-0000320193/0f83e3d6-e02c-4fbe-b806-8b10507695fd.xls\n"
     ]
    }
   ],
   "source": [
    "# 下载\n",
    "import urllib.request\n",
    "for year_data in data['GetEdgarFilingListResult']:\n",
    "    year = year_data['FilingDate'].split()[0].split('/')[-1]\n",
    "    for doc in year_data['DocumentList']:\n",
    "        if doc['DocumentType'] == 'XLS':\n",
    "            url_xls = doc['Url']\n",
    "            break\n",
    "    print(year, url_xls)\n",
    "    urllib.request.urlretrieve(url_xls, str(year) + '.xls')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "------------------- 2008\n",
      "WARNING *** OLE2 inconsistency: SSCS size is 0 but SSAT size is non-zero\n",
      "\n",
      "------------------- 2009\n",
      "WARNING *** OLE2 inconsistency: SSCS size is 0 but SSAT size is non-zero\n",
      "\n",
      "------------------- 2010\n",
      "WARNING *** file size (279814) not 512 + multiple of sector size (512)\n",
      "WARNING *** OLE2 inconsistency: SSCS size is 0 but SSAT size is non-zero\n",
      "\n",
      "------------------- 2011\n",
      "WARNING *** file size (254962) not 512 + multiple of sector size (512)\n",
      "WARNING *** OLE2 inconsistency: SSCS size is 0 but SSAT size is non-zero\n",
      "TABLE35\n",
      "[nan 'China (a)' 12472.0 2764.0 769.0] \n",
      "\n",
      "TABLE35\n",
      "[nan 'China (a)' 2613.0 1245.0 365.0] \n",
      "\n",
      "\n",
      "------------------- 2012\n",
      "WARNING *** file size (129915) not 512 + multiple of sector size (512)\n",
      "WARNING *** OLE2 inconsistency: SSCS size is 0 but SSAT size is non-zero\n",
      "TABLE34\n",
      "[nan 'China (a)' 22797.0 12472.0 2764.0] \n",
      "\n",
      "TABLE35\n",
      "[nan 'China (a)' 7314.0 2613.0] \n",
      "\n",
      "\n",
      "------------------- 2013\n",
      "WARNING *** file size (169107) not 512 + multiple of sector size (512)\n",
      "WARNING *** OLE2 inconsistency: SSCS size is 0 but SSAT size is non-zero\n",
      "TABLE6\n",
      "[nan 'Greater China (a)' 25417.0 0.13 22533.0 0.78 12690.0] \n",
      "\n",
      "TABLE13\n",
      "[nan 'Greater China' nan nan nan nan nan] \n",
      "\n",
      "TABLE13\n",
      "[nan\n",
      " 'The following table presents Greater China net sales information for 2013, 2012'\n",
      " nan nan nan nan nan] \n",
      "\n",
      "TABLE50\n",
      "[nan 'Greater China:' nan nan nan] \n",
      "\n",
      "TABLE52\n",
      "[nan 'Greater China' 2943.0 1321.0] \n",
      "\n",
      "TABLE53\n",
      "[nan 'China (a)' 25946.0 22797.0 12472.0] \n",
      "\n",
      "TABLE53\n",
      "[nan 'China (a)' 7403.0 7314.0 nan] \n",
      "\n",
      "\n",
      "------------------- 2014\n",
      "WARNING *** file size (184332) not 512 + multiple of sector size (512)\n",
      "WARNING *** OLE2 inconsistency: SSCS size is 0 but SSAT size is non-zero\n",
      "TABLE6\n",
      "[nan 'Greater China' 29846.0 0.17 25417.0 0.13 22533.0] \n",
      "\n",
      "TABLE13\n",
      "[nan 'Greater China' nan nan nan nan nan] \n",
      "\n",
      "TABLE13\n",
      "[nan\n",
      " 'The following table presents Greater China net sales information for 2014, 2013'\n",
      " nan nan nan nan nan] \n",
      "\n",
      "TABLE52\n",
      "[nan 'Greater China:' nan nan nan] \n",
      "\n",
      "BALANCE_SHEET2\n",
      "[nan 'Greater China' 3172.0 2943.0] \n",
      "\n",
      "TABLE54\n",
      "[nan 'China (1)' 30638.0 25946.0 22797.0] \n",
      "\n",
      "TABLE54\n",
      "[nan 'China (1)' 9477.0 7403.0 nan] \n",
      "\n",
      "\n",
      "------------------- 2015\n",
      "WARNING *** file size (217771) not 512 + multiple of sector size (512)\n",
      "WARNING *** OLE2 inconsistency: SSCS size is 0 but SSAT size is non-zero\n",
      "TABLE7\n",
      "[nan 'Greater China' 58715.0 0.84 31853.0 0.18 27016.0] \n",
      "\n",
      "TABLE14\n",
      "[nan 'Greater China' nan nan nan nan nan] \n",
      "\n",
      "TABLE14\n",
      "[nan\n",
      " 'The following table presents Greater China net sales information for 2015, 2014'\n",
      " nan nan nan nan nan] \n",
      "\n",
      "TABLE53\n",
      "[nan 'Greater China:' nan nan nan] \n",
      "\n",
      "TABLE55\n",
      "[nan 'China (1)' 56547.0 30638.0 25946.0] \n",
      "\n",
      "TABLE55\n",
      "[nan 'China (1)' 8722.0 9477.0 nan] \n",
      "\n",
      "\n",
      "------------------- 2016\n",
      "WARNING *** OLE2 inconsistency: SSCS size is 0 but SSAT size is non-zero\n",
      "TABLE7\n",
      "[nan 'Greater China' 48492.0 '(17' ')%' 58715.0 0.84 31853.0] \n",
      "\n",
      "TABLE14\n",
      "[nan 'Greater China' nan nan nan nan nan nan] \n",
      "\n",
      "TABLE14\n",
      "[nan\n",
      " 'The following table presents Greater China net sales information for 2016, 2015'\n",
      " nan nan nan nan nan nan] \n",
      "\n",
      "TABLE49\n",
      "[nan 'Greater China:' nan nan nan] \n",
      "\n",
      "TABLE51\n",
      "[nan\n",
      " 'The U.S. and China were the only countries that accounted for more than 10% of'\n",
      " nan nan nan] \n",
      "\n",
      "TABLE51\n",
      "[nan 'China (1)' 46349 56547.0 30638.0] \n",
      "\n",
      "TABLE51\n",
      "[nan 'China (1)' nan 7807.0 8722.0] \n",
      "\n",
      "\n",
      "------------------- 2017\n",
      "WARNING *** file size (257363) not 512 + multiple of sector size (512)\n",
      "WARNING *** OLE2 inconsistency: SSCS size is 0 but SSAT size is non-zero\n",
      "TABLE8\n",
      "[nan 'Greater China' 44764.0 -0.08 48492.0 '(17' ')%' 58715.0] \n",
      "\n",
      "TABLE15\n",
      "[nan 'Greater China' nan nan nan nan nan nan nan] \n",
      "\n",
      "TABLE15\n",
      "[nan\n",
      " 'The following table presents Greater China net sales information for 2017, 2016'\n",
      " nan nan nan nan nan nan nan] \n",
      "\n",
      "TABLE54\n",
      "[nan 'Greater China:' nan nan nan] \n",
      "\n",
      "TABLE56\n",
      "[nan\n",
      " 'The U.S. and China were the only countries that accounted for more than 10% of'\n",
      " nan nan nan] \n",
      "\n",
      "TABLE56\n",
      "[nan 'China (1)' 44764 48492.0 58715.0] \n",
      "\n",
      "TABLE56\n",
      "[nan 'China (1)' nan 10211.0 7875.0] \n",
      "\n",
      "SUBSIDIARIES\n",
      "[nan 'Apple Computer Trading (Shanghai) Co., Ltd.' 'China'] \n",
      "\n"
     ]
    }
   ],
   "source": [
    "# 从文件中搜索相关信息\n",
    "import pandas as pd\n",
    "for y in range(2008, 2018):\n",
    "    print('\\n-------------------', y)\n",
    "    ex = pd.ExcelFile('data/%d.xls' % y)\n",
    "    sheets = pd.read_excel(ex, None)\n",
    "    for sheet in sheets:\n",
    "        s = sheets[sheet]\n",
    "        for index, row in s.iterrows():\n",
    "            line = str(row.values)\n",
    "#             if 'iphone' in line.lower() and '.' in line:\n",
    "#             if 'total net sales' in line.lower() and '.' in line:\n",
    "#             if 'net income' in line.lower() and '.' in line:\n",
    "#             if 'gross margin percentage' in line.lower() and '.' in line:\n",
    "#             if 'cash equivalents' in line.lower():\n",
    "#             if 'total assets' in line.lower():\n",
    "            if 'china' in line.lower():\n",
    "                print(sheet)\n",
    "                print(line, '\\n')\n",
    "    ex.close()\n",
    "                "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 187,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>2008</th>\n",
       "      <th>2009</th>\n",
       "      <th>2010</th>\n",
       "      <th>2011</th>\n",
       "      <th>2012</th>\n",
       "      <th>2013</th>\n",
       "      <th>2014</th>\n",
       "      <th>2015</th>\n",
       "      <th>2016</th>\n",
       "      <th>2017</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>iPhone销售额</th>\n",
       "      <td>6742.0</td>\n",
       "      <td>13033.0</td>\n",
       "      <td>25179.0</td>\n",
       "      <td>47057.0</td>\n",
       "      <td>80477.0</td>\n",
       "      <td>91279.0</td>\n",
       "      <td>101991.0</td>\n",
       "      <td>155041.0</td>\n",
       "      <td>136700.0</td>\n",
       "      <td>141319.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>iPhone销量</th>\n",
       "      <td>11627.0</td>\n",
       "      <td>20731.0</td>\n",
       "      <td>39989.0</td>\n",
       "      <td>72293.0</td>\n",
       "      <td>125046.0</td>\n",
       "      <td>150257.0</td>\n",
       "      <td>169219.0</td>\n",
       "      <td>231218.0</td>\n",
       "      <td>211884.0</td>\n",
       "      <td>216756.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>净利润</th>\n",
       "      <td>4834.0</td>\n",
       "      <td>8235.0</td>\n",
       "      <td>14013.0</td>\n",
       "      <td>25922.0</td>\n",
       "      <td>41733.0</td>\n",
       "      <td>37037.0</td>\n",
       "      <td>39510.0</td>\n",
       "      <td>53394.0</td>\n",
       "      <td>45687.0</td>\n",
       "      <td>48351.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>净销售额</th>\n",
       "      <td>32479.0</td>\n",
       "      <td>42905.0</td>\n",
       "      <td>65225.0</td>\n",
       "      <td>108249.0</td>\n",
       "      <td>156508.0</td>\n",
       "      <td>170910.0</td>\n",
       "      <td>182795.0</td>\n",
       "      <td>233715.0</td>\n",
       "      <td>215639.0</td>\n",
       "      <td>229234.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>国行</th>\n",
       "      <td>0</td>\n",
       "      <td>769.0</td>\n",
       "      <td>2764.0</td>\n",
       "      <td>12472.0</td>\n",
       "      <td>22797.0</td>\n",
       "      <td>25946.0</td>\n",
       "      <td>30638.0</td>\n",
       "      <td>56547.0</td>\n",
       "      <td>46349</td>\n",
       "      <td>44764</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>总资产</th>\n",
       "      <td>36171</td>\n",
       "      <td>47501</td>\n",
       "      <td>75183</td>\n",
       "      <td>116371</td>\n",
       "      <td>176064</td>\n",
       "      <td>207000</td>\n",
       "      <td>231839</td>\n",
       "      <td>290479</td>\n",
       "      <td>321686</td>\n",
       "      <td>375319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>毛利率</th>\n",
       "      <td>0.342</td>\n",
       "      <td>0.401</td>\n",
       "      <td>0.394</td>\n",
       "      <td>0.405</td>\n",
       "      <td>0.439</td>\n",
       "      <td>0.376</td>\n",
       "      <td>0.386</td>\n",
       "      <td>0.401</td>\n",
       "      <td>0.391</td>\n",
       "      <td>0.385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>现金</th>\n",
       "      <td>11875.0</td>\n",
       "      <td>5263.0</td>\n",
       "      <td>11261.0</td>\n",
       "      <td>9815.0</td>\n",
       "      <td>10746</td>\n",
       "      <td>14259</td>\n",
       "      <td>13844</td>\n",
       "      <td>21120</td>\n",
       "      <td>20484</td>\n",
       "      <td>20289</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              2008     2009     2010      2011      2012      2013      2014  \\\n",
       "iPhone销售额   6742.0  13033.0  25179.0   47057.0   80477.0   91279.0  101991.0   \n",
       "iPhone销量   11627.0  20731.0  39989.0   72293.0  125046.0  150257.0  169219.0   \n",
       "净利润         4834.0   8235.0  14013.0   25922.0   41733.0   37037.0   39510.0   \n",
       "净销售额       32479.0  42905.0  65225.0  108249.0  156508.0  170910.0  182795.0   \n",
       "国行               0    769.0   2764.0   12472.0   22797.0   25946.0   30638.0   \n",
       "总资产          36171    47501    75183    116371    176064    207000    231839   \n",
       "毛利率          0.342    0.401    0.394     0.405     0.439     0.376     0.386   \n",
       "现金         11875.0   5263.0  11261.0    9815.0     10746     14259     13844   \n",
       "\n",
       "               2015      2016      2017  \n",
       "iPhone销售额  155041.0  136700.0  141319.0  \n",
       "iPhone销量   231218.0  211884.0  216756.0  \n",
       "净利润         53394.0   45687.0   48351.0  \n",
       "净销售额       233715.0  215639.0  229234.0  \n",
       "国行          56547.0     46349     44764  \n",
       "总资产          290479    321686    375319  \n",
       "毛利率           0.401     0.391     0.385  \n",
       "现金            21120     20484     20289  "
      ]
     },
     "execution_count": 187,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 转换数据格式\n",
    "table = '''\n",
    "净销售额       净利润     毛利率     现金      总资产     国行     iPhone销量    iPhone销售额\n",
    "32479.0     4834.0      0.342   11875.0     36171   0           11627.0     6742.0\n",
    "42905.0     8235.0      0.401   5263.0      47501   769.0       20731.0     13033.0\n",
    "65225.0     14013.0     0.394   11261.0     75183   2764.0      39989.0     25179.0\n",
    "108249.0    25922.0     0.405   9815.0      116371  12472.0     72293.0     47057.0\n",
    "156508.0    41733.0     0.439   10746       176064  22797.0     125046.0    80477.0\n",
    "170910.0    37037.0     0.376   14259       207000  25946.0     150257.0    91279.0\n",
    "182795.0    39510.0     0.386   13844       231839  30638.0     169219.0    101991.0\n",
    "233715.0    53394.0     0.401   21120       290479  56547.0     231218.0    155041.0\n",
    "215639.0    45687.0     0.391   20484       321686  46349       211884.0    136700.0\n",
    "229234.0    48351.0     0.385   20289       375319  44764       216756.0    141319.0\n",
    "'''\n",
    "table = table.strip().split('\\n')\n",
    "head = table[0].split()\n",
    "body = table[1:]\n",
    "data = {}\n",
    "year = 2008\n",
    "for line in body:\n",
    "    data_year = {}\n",
    "    line = line.split()\n",
    "    for i in range(len(head)):\n",
    "        data_year[head[i]] = line[i]\n",
    "    data[year] = data_year\n",
    "    year += 1\n",
    "data = pd.DataFrame(data)\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 239,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"9953958b1ee84a418c581be013949398\" style=\"width:800px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_9953958b1ee84a418c581be013949398 = echarts.init(document.getElementById('9953958b1ee84a418c581be013949398'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_9953958b1ee84a418c581be013949398 = {\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"boundaryGap\": true,\n",
       "            \"nameGap\": 60,\n",
       "            \"inverse\": false,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"name\": \"\\u767e\\u4e07\\u7f8e\\u5143\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"type\": \"value\",\n",
       "            \"axisLabel\": {\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                },\n",
       "                \"interval\": \"auto\",\n",
       "                \"margin\": 8,\n",
       "                \"rotate\": 0,\n",
       "                \"formatter\": \"{value} \"\n",
       "            }\n",
       "        },\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"boundaryGap\": true,\n",
       "            \"nameGap\": 25,\n",
       "            \"inverse\": false,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"type\": \"value\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                },\n",
       "                \"formatter\": \"{value} \",\n",
       "                \"margin\": 8,\n",
       "                \"rotate\": 0,\n",
       "                \"interval\": \"auto\"\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"boundaryGap\": true,\n",
       "            \"nameGap\": 25,\n",
       "            \"inverse\": false,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"data\": [\n",
       "                \"2008\",\n",
       "                \"2009\",\n",
       "                \"2010\",\n",
       "                \"2011\",\n",
       "                \"2012\",\n",
       "                \"2013\",\n",
       "                \"2014\",\n",
       "                \"2015\",\n",
       "                \"2016\",\n",
       "                \"2017\"\n",
       "            ],\n",
       "            \"type\": \"category\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": false\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                },\n",
       "                \"margin\": 8,\n",
       "                \"rotate\": 0,\n",
       "                \"interval\": \"auto\"\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"top\": \"auto\",\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            },\n",
       "            \"text\": \"\\u76c8\\u5229\\u80fd\\u529b\",\n",
       "            \"left\": \"auto\"\n",
       "        }\n",
       "    ],\n",
       "    \"series_id\": 1340614,\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                32479.0,\n",
       "                42905.0,\n",
       "                65225.0,\n",
       "                108249.0,\n",
       "                156508.0,\n",
       "                170910.0,\n",
       "                182795.0,\n",
       "                233715.0,\n",
       "                215639.0,\n",
       "                229234.0\n",
       "            ],\n",
       "            \"name\": \"\\u51c0\\u9500\\u552e\\u989d\",\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"type\": \"bar\",\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 1340614,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            },\n",
       "            \"barCategoryGap\": \"20%\"\n",
       "        },\n",
       "        {\n",
       "            \"data\": [\n",
       "                4834.0,\n",
       "                8235.0,\n",
       "                14013.0,\n",
       "                25922.0,\n",
       "                41733.0,\n",
       "                37037.0,\n",
       "                39510.0,\n",
       "                53394.0,\n",
       "                45687.0,\n",
       "                48351.0\n",
       "            ],\n",
       "            \"name\": \"\\u51c0\\u5229\\u6da6\",\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"type\": \"bar\",\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 1340614,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            },\n",
       "            \"barCategoryGap\": 25\n",
       "        },\n",
       "        {\n",
       "            \"lineStyle\": {\n",
       "                \"normal\": {\n",
       "                    \"opacity\": 1,\n",
       "                    \"curveness\": 0,\n",
       "                    \"width\": 3,\n",
       "                    \"type\": \"solid\"\n",
       "                }\n",
       "            },\n",
       "            \"data\": [\n",
       "                [\n",
       "                    \"2008\",\n",
       "                    \"0.342\"\n",
       "                ],\n",
       "                [\n",
       "                    \"2009\",\n",
       "                    \"0.401\"\n",
       "                ],\n",
       "                [\n",
       "                    \"2010\",\n",
       "                    \"0.394\"\n",
       "                ],\n",
       "                [\n",
       "                    \"2011\",\n",
       "                    \"0.405\"\n",
       "                ],\n",
       "                [\n",
       "                    \"2012\",\n",
       "                    \"0.439\"\n",
       "                ],\n",
       "                [\n",
       "                    \"2013\",\n",
       "                    \"0.376\"\n",
       "                ],\n",
       "                [\n",
       "                    \"2014\",\n",
       "                    \"0.386\"\n",
       "                ],\n",
       "                [\n",
       "                    \"2015\",\n",
       "                    \"0.401\"\n",
       "                ],\n",
       "                [\n",
       "                    \"2016\",\n",
       "                    \"0.391\"\n",
       "                ],\n",
       "                [\n",
       "                    \"2017\",\n",
       "                    \"0.385\"\n",
       "                ]\n",
       "            ],\n",
       "            \"symbol\": \"emptyCircle\",\n",
       "            \"xAxisIndex\": 0,\n",
       "            \"smooth\": false,\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 1340614,\n",
       "            \"showSymbol\": true,\n",
       "            \"name\": \"\\u6bdb\\u5229\\u7387\",\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"type\": \"line\",\n",
       "            \"step\": false,\n",
       "            \"symbolSize\": 4,\n",
       "            \"yAxisIndex\": 1,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"tooltip\": {\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"borderWidth\": 0,\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"trigger\": \"item\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        }\n",
       "    },\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u51c0\\u9500\\u552e\\u989d\",\n",
       "                \"\\u51c0\\u5229\\u6da6\",\n",
       "                \"\\u6bdb\\u5229\\u7387\"\n",
       "            ],\n",
       "            \"show\": true,\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            },\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"selectedMode\": \"multiple\"\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"dataView\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"\\u4e0b\\u8f7d\\u56fe\\u7247\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true\n",
       "            }\n",
       "        },\n",
       "        \"left\": \"95%\"\n",
       "    }\n",
       "};\n",
       "myChart_9953958b1ee84a418c581be013949398.setOption(option_9953958b1ee84a418c581be013949398);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.custom.overlap.Overlap at 0x10ffbe5f8>"
      ]
     },
     "execution_count": 239,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from pyecharts import Bar, Line, Overlap, Grid\n",
    "\n",
    "years = [str(i) for i in range(2008, 2018)]\n",
    "net_sales = data.loc['净销售额'].values\n",
    "net_income = data.loc['净利润'].values\n",
    "bar = Bar(\"盈利能力\")\n",
    "bar.add(\"净销售额\", years, net_sales)\n",
    "bar.add(\"净利润\", years, net_income, bar_category_gap=25, yaxis_name='百万美元', yaxis_name_gap=60)\n",
    "gross = data.loc['毛利率'].values\n",
    "line = Line()\n",
    "line.add(\"毛利率\", years, gross, line_width=3)\n",
    "ol = Overlap()\n",
    "ol.add(bar)\n",
    "ol.add(line, is_add_yaxis=True, yaxis_index=1)\n",
    "ol"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 241,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"c7c458f106464725bc35d68574c64356\" style=\"width:800px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_c7c458f106464725bc35d68574c64356 = echarts.init(document.getElementById('c7c458f106464725bc35d68574c64356'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_c7c458f106464725bc35d68574c64356 = {\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"boundaryGap\": true,\n",
       "            \"nameGap\": 60,\n",
       "            \"inverse\": false,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"name\": \"\\u767e\\u4e07\\u7f8e\\u5143\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"type\": \"value\",\n",
       "            \"axisLabel\": {\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                },\n",
       "                \"formatter\": \"{value} \",\n",
       "                \"margin\": 8,\n",
       "                \"rotate\": 0,\n",
       "                \"interval\": \"auto\"\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"boundaryGap\": true,\n",
       "            \"nameGap\": 25,\n",
       "            \"inverse\": false,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"data\": [\n",
       "                \"2008\",\n",
       "                \"2009\",\n",
       "                \"2010\",\n",
       "                \"2011\",\n",
       "                \"2012\",\n",
       "                \"2013\",\n",
       "                \"2014\",\n",
       "                \"2015\",\n",
       "                \"2016\",\n",
       "                \"2017\"\n",
       "            ],\n",
       "            \"type\": \"category\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": false\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                },\n",
       "                \"margin\": 8,\n",
       "                \"rotate\": 0,\n",
       "                \"interval\": \"auto\"\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"top\": \"auto\",\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            },\n",
       "            \"text\": \"\\u8d22\\u52a1\\u72b6\\u51b5\",\n",
       "            \"left\": \"auto\"\n",
       "        }\n",
       "    ],\n",
       "    \"series_id\": 98119,\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                36171.0,\n",
       "                47501.0,\n",
       "                75183.0,\n",
       "                116371.0,\n",
       "                176064.0,\n",
       "                207000.0,\n",
       "                231839.0,\n",
       "                290479.0,\n",
       "                321686.0,\n",
       "                375319.0\n",
       "            ],\n",
       "            \"name\": \"\\u603b\\u8d44\\u4ea7\",\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"type\": \"bar\",\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 98119,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            },\n",
       "            \"barCategoryGap\": \"20%\"\n",
       "        },\n",
       "        {\n",
       "            \"data\": [\n",
       "                11875.0,\n",
       "                5263.0,\n",
       "                11261.0,\n",
       "                9815.0,\n",
       "                10746.0,\n",
       "                14259.0,\n",
       "                13844.0,\n",
       "                21120.0,\n",
       "                20484.0,\n",
       "                20289.0\n",
       "            ],\n",
       "            \"name\": \"\\u73b0\\u91d1\",\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"type\": \"bar\",\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 98119,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            },\n",
       "            \"barCategoryGap\": 25\n",
       "        }\n",
       "    ],\n",
       "    \"tooltip\": {\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"borderWidth\": 0,\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"trigger\": \"item\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        }\n",
       "    },\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u603b\\u8d44\\u4ea7\",\n",
       "                \"\\u73b0\\u91d1\"\n",
       "            ],\n",
       "            \"show\": true,\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            },\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"selectedMode\": \"multiple\"\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"dataView\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"\\u4e0b\\u8f7d\\u56fe\\u7247\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true\n",
       "            }\n",
       "        },\n",
       "        \"left\": \"95%\"\n",
       "    }\n",
       "};\n",
       "myChart_c7c458f106464725bc35d68574c64356.setOption(option_c7c458f106464725bc35d68574c64356);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.charts.bar.Bar at 0x111428da0>"
      ]
     },
     "execution_count": 241,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "assets = data.loc['总资产'].values\n",
    "cash = data.loc['现金'].values\n",
    "bar = Bar(\"财务状况\")\n",
    "bar.add(\"总资产\", years, assets)\n",
    "bar.add(\"现金\", years, cash, bar_category_gap=25, yaxis_name='百万美元', yaxis_name_gap=60)\n",
    "bar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 233,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"57d6c697ff3642ffa2eec85023b59b30\" style=\"width:800px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_57d6c697ff3642ffa2eec85023b59b30 = echarts.init(document.getElementById('57d6c697ff3642ffa2eec85023b59b30'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_57d6c697ff3642ffa2eec85023b59b30 = {\n",
       "    \"grid\": [\n",
       "        {\n",
       "            \"left\": \"15%\"\n",
       "        },\n",
       "        {\n",
       "            \"left\": \"15%\"\n",
       "        },\n",
       "        {\n",
       "            \"left\": \"15%\"\n",
       "        }\n",
       "    ],\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"boundaryGap\": true,\n",
       "            \"nameGap\": 25,\n",
       "            \"inverse\": false,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"type\": \"value\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                },\n",
       "                \"formatter\": \"{value} \",\n",
       "                \"margin\": 8,\n",
       "                \"interval\": \"auto\",\n",
       "                \"rotate\": 0\n",
       "            }\n",
       "        },\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"boundaryGap\": true,\n",
       "            \"nameGap\": 25,\n",
       "            \"inverse\": false,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"type\": \"value\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                },\n",
       "                \"interval\": \"auto\",\n",
       "                \"margin\": 8,\n",
       "                \"rotate\": 0,\n",
       "                \"formatter\": \"{value} \"\n",
       "            }\n",
       "        },\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"boundaryGap\": true,\n",
       "            \"nameGap\": 25,\n",
       "            \"inverse\": false,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"type\": \"value\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"position\": \"left\",\n",
       "            \"axisLabel\": {\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                },\n",
       "                \"interval\": \"auto\",\n",
       "                \"margin\": 60,\n",
       "                \"rotate\": 0,\n",
       "                \"formatter\": \"{value} \"\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"boundaryGap\": true,\n",
       "            \"nameGap\": 25,\n",
       "            \"inverse\": false,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"data\": [\n",
       "                \"2008\",\n",
       "                \"2009\",\n",
       "                \"2010\",\n",
       "                \"2011\",\n",
       "                \"2012\",\n",
       "                \"2013\",\n",
       "                \"2014\",\n",
       "                \"2015\",\n",
       "                \"2016\",\n",
       "                \"2017\"\n",
       "            ],\n",
       "            \"type\": \"category\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": false\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                },\n",
       "                \"margin\": 8,\n",
       "                \"interval\": \"auto\",\n",
       "                \"rotate\": 0\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"top\": \"auto\",\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            },\n",
       "            \"text\": \"iPhone\\u9500\\u552e\\u72b6\\u51b5\",\n",
       "            \"left\": \"auto\"\n",
       "        }\n",
       "    ],\n",
       "    \"series_id\": 2039732,\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                6742.0,\n",
       "                13033.0,\n",
       "                25179.0,\n",
       "                47057.0,\n",
       "                80477.0,\n",
       "                91279.0,\n",
       "                101991.0,\n",
       "                155041.0,\n",
       "                136700.0,\n",
       "                141319.0\n",
       "            ],\n",
       "            \"name\": \"iPhone\\u9500\\u552e\\u989d\",\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"type\": \"bar\",\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 2039732,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            },\n",
       "            \"barCategoryGap\": \"20%\"\n",
       "        },\n",
       "        {\n",
       "            \"data\": [\n",
       "                11627.0,\n",
       "                20731.0,\n",
       "                39989.0,\n",
       "                72293.0,\n",
       "                125046.0,\n",
       "                150257.0,\n",
       "                169219.0,\n",
       "                231218.0,\n",
       "                211884.0,\n",
       "                216756.0\n",
       "            ],\n",
       "            \"name\": \"iPhone\\u9500\\u91cf\",\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"type\": \"bar\",\n",
       "            \"xAxisIndex\": 0,\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"yAxisIndex\": 1,\n",
       "            \"seriesId\": 2039732,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            },\n",
       "            \"barCategoryGap\": 25\n",
       "        },\n",
       "        {\n",
       "            \"lineStyle\": {\n",
       "                \"normal\": {\n",
       "                    \"opacity\": 1,\n",
       "                    \"curveness\": 0,\n",
       "                    \"width\": 3,\n",
       "                    \"type\": \"solid\"\n",
       "                }\n",
       "            },\n",
       "            \"data\": [\n",
       "                [\n",
       "                    \"2008\",\n",
       "                    0.20758028264417008\n",
       "                ],\n",
       "                [\n",
       "                    \"2009\",\n",
       "                    0.30376413005477215\n",
       "                ],\n",
       "                [\n",
       "                    \"2010\",\n",
       "                    0.3860329628210042\n",
       "                ],\n",
       "                [\n",
       "                    \"2011\",\n",
       "                    0.4347107132629401\n",
       "                ],\n",
       "                [\n",
       "                    \"2012\",\n",
       "                    0.5142037467733279\n",
       "                ],\n",
       "                [\n",
       "                    \"2013\",\n",
       "                    0.534076414487157\n",
       "                ],\n",
       "                [\n",
       "                    \"2014\",\n",
       "                    0.5579528980551984\n",
       "                ],\n",
       "                [\n",
       "                    \"2015\",\n",
       "                    0.6633763344244058\n",
       "                ],\n",
       "                [\n",
       "                    \"2016\",\n",
       "                    0.6339298549891254\n",
       "                ],\n",
       "                [\n",
       "                    \"2017\",\n",
       "                    0.6164835931842572\n",
       "                ]\n",
       "            ],\n",
       "            \"symbol\": \"emptyCircle\",\n",
       "            \"xAxisIndex\": 0,\n",
       "            \"smooth\": false,\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 2039732,\n",
       "            \"showSymbol\": true,\n",
       "            \"name\": \"\\u6536\\u5165\\u5360\\u6bd4\",\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"type\": \"line\",\n",
       "            \"step\": false,\n",
       "            \"symbolSize\": 4,\n",
       "            \"yAxisIndex\": 2,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"tooltip\": {\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"borderWidth\": 0,\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"trigger\": \"item\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        }\n",
       "    },\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"iPhone\\u9500\\u552e\\u989d\",\n",
       "                \"iPhone\\u9500\\u91cf\",\n",
       "                \"\\u6536\\u5165\\u5360\\u6bd4\"\n",
       "            ],\n",
       "            \"show\": true,\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            },\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"selectedMode\": \"multiple\"\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"dataView\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"\\u4e0b\\u8f7d\\u56fe\\u7247\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true\n",
       "            }\n",
       "        },\n",
       "        \"left\": \"95%\"\n",
       "    }\n",
       "};\n",
       "myChart_57d6c697ff3642ffa2eec85023b59b30.setOption(option_57d6c697ff3642ffa2eec85023b59b30);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.custom.grid.Grid at 0x111322828>"
      ]
     },
     "execution_count": 233,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ip_sales = data.loc['iPhone销售额'].values\n",
    "ip_unit = data.loc['iPhone销量'].values\n",
    "bar = Bar(\"iPhone销售状况\")\n",
    "bar.add(\"iPhone销售额\", years, ip_sales)\n",
    "bar2 = Bar()\n",
    "bar2.add(\"iPhone销量\", years, ip_unit, bar_category_gap=25)\n",
    "percent = ip_sales.astype('float') / net_sales.astype('float')\n",
    "line = Line()\n",
    "line.add(\"收入占比\", years, percent, line_width=3, yaxis_margin=60, yaxis_pos='left')\n",
    "ol = Overlap()\n",
    "ol.add(bar)\n",
    "ol.add(bar2, is_add_yaxis=True, yaxis_index=1)\n",
    "ol.add(line, is_add_yaxis=True, yaxis_index=2)\n",
    "grid = Grid()\n",
    "grid.add(ol, grid_left=\"15%\")\n",
    "grid"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 189,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"1b8a9f38254e453baf7584149886a67f\" style=\"width:800px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_1b8a9f38254e453baf7584149886a67f = echarts.init(document.getElementById('1b8a9f38254e453baf7584149886a67f'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_1b8a9f38254e453baf7584149886a67f = {\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"boundaryGap\": true,\n",
       "            \"nameGap\": 25,\n",
       "            \"inverse\": false,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"type\": \"value\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                },\n",
       "                \"interval\": \"auto\",\n",
       "                \"margin\": 8,\n",
       "                \"rotate\": 0,\n",
       "                \"formatter\": \"{value} \"\n",
       "            }\n",
       "        },\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"boundaryGap\": true,\n",
       "            \"nameGap\": 25,\n",
       "            \"inverse\": false,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"type\": \"value\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                },\n",
       "                \"formatter\": \"{value} \",\n",
       "                \"margin\": 8,\n",
       "                \"rotate\": 0,\n",
       "                \"interval\": \"auto\"\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"boundaryGap\": true,\n",
       "            \"nameGap\": 25,\n",
       "            \"inverse\": false,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"data\": [\n",
       "                \"2008\",\n",
       "                \"2009\",\n",
       "                \"2010\",\n",
       "                \"2011\",\n",
       "                \"2012\",\n",
       "                \"2013\",\n",
       "                \"2014\",\n",
       "                \"2015\",\n",
       "                \"2016\",\n",
       "                \"2017\"\n",
       "            ],\n",
       "            \"type\": \"category\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": false\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                },\n",
       "                \"margin\": 8,\n",
       "                \"rotate\": 0,\n",
       "                \"interval\": \"auto\"\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"top\": \"auto\",\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            },\n",
       "            \"text\": \"\\u56fd\\u884c\\u9500\\u552e\\u72b6\\u51b5\",\n",
       "            \"left\": \"auto\"\n",
       "        }\n",
       "    ],\n",
       "    \"series_id\": 5956767,\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                0.0,\n",
       "                769.0,\n",
       "                2764.0,\n",
       "                12472.0,\n",
       "                22797.0,\n",
       "                25946.0,\n",
       "                30638.0,\n",
       "                56547.0,\n",
       "                46349.0,\n",
       "                44764.0\n",
       "            ],\n",
       "            \"name\": \"\\u56fd\\u884c\",\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"type\": \"bar\",\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 5956767,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            },\n",
       "            \"barCategoryGap\": \"20%\"\n",
       "        },\n",
       "        {\n",
       "            \"lineStyle\": {\n",
       "                \"normal\": {\n",
       "                    \"opacity\": 1,\n",
       "                    \"curveness\": 0,\n",
       "                    \"width\": 3,\n",
       "                    \"type\": \"solid\"\n",
       "                }\n",
       "            },\n",
       "            \"data\": [\n",
       "                [\n",
       "                    \"2008\",\n",
       "                    0.0\n",
       "                ],\n",
       "                [\n",
       "                    \"2009\",\n",
       "                    0.017923318960494115\n",
       "                ],\n",
       "                [\n",
       "                    \"2010\",\n",
       "                    0.04237638942123419\n",
       "                ],\n",
       "                [\n",
       "                    \"2011\",\n",
       "                    0.11521584495006883\n",
       "                ],\n",
       "                [\n",
       "                    \"2012\",\n",
       "                    0.14566028573619239\n",
       "                ],\n",
       "                [\n",
       "                    \"2013\",\n",
       "                    0.15181089462290095\n",
       "                ],\n",
       "                [\n",
       "                    \"2014\",\n",
       "                    0.16760852320905933\n",
       "                ],\n",
       "                [\n",
       "                    \"2015\",\n",
       "                    0.24194852705217892\n",
       "                ],\n",
       "                [\n",
       "                    \"2016\",\n",
       "                    0.21493792866781983\n",
       "                ],\n",
       "                [\n",
       "                    \"2017\",\n",
       "                    0.1952764424125566\n",
       "                ]\n",
       "            ],\n",
       "            \"symbol\": \"emptyCircle\",\n",
       "            \"xAxisIndex\": 0,\n",
       "            \"smooth\": false,\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 5956767,\n",
       "            \"showSymbol\": true,\n",
       "            \"name\": \"\\u56fd\\u884c\\u5360\\u6bd4\",\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"type\": \"line\",\n",
       "            \"step\": false,\n",
       "            \"symbolSize\": 4,\n",
       "            \"yAxisIndex\": 1,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"tooltip\": {\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"borderWidth\": 0,\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"trigger\": \"item\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        }\n",
       "    },\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u56fd\\u884c\",\n",
       "                \"\\u56fd\\u884c\\u5360\\u6bd4\"\n",
       "            ],\n",
       "            \"show\": true,\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            },\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"selectedMode\": \"multiple\"\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"dataView\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"\\u4e0b\\u8f7d\\u56fe\\u7247\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true\n",
       "            }\n",
       "        },\n",
       "        \"left\": \"95%\"\n",
       "    }\n",
       "};\n",
       "myChart_1b8a9f38254e453baf7584149886a67f.setOption(option_1b8a9f38254e453baf7584149886a67f);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.custom.overlap.Overlap at 0x1113fff28>"
      ]
     },
     "execution_count": 189,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cn_sales = data.loc['国行'].values\n",
    "bar = Bar(\"国行销售状况\")\n",
    "bar.add(\"国行\", years, cn_sales)\n",
    "percent = cn_sales.astype('float') / net_sales.astype('float')\n",
    "line = Line()\n",
    "line.add(\"国行占比\", years, percent, line_width=3)\n",
    "ol = Overlap()\n",
    "ol.add(bar)\n",
    "ol.add(line, is_add_yaxis=True, yaxis_index=1)\n",
    "ol"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 191,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['iPhone (2007)', 'iPhone 3G (2008)', 'iPhone 3GS (2009)', 'iPhone 4 (2010)', 'iPhone 4S (2011)', 'iPhone 5 (2012)', 'iPhone 5c (2013)', 'iPhone 5s (2013)', 'iPhone 6 (2014)', 'iPhone 6 Plus (2014)', 'iPhone 6s (2015)', 'iPhone 6s Plus (2015)', 'iPhone SE (2016)', 'iPhone 7 (2016)', 'iPhone 7 Plus (2016)', 'iPhone 8 (2017)', 'iPhone 8 Plus (2017)', 'iPhone X (2017)', 'iPhone Xr (2018)', 'iPhone Xs (2018)', 'iPhone Xs Max (2018)'] ['499', '599', '599', '599', '649', '649', '549', '649', '649', '749', '649', '749', '399', '649', '769', '699', '799', '999', '749', '999', '1099'] ['599', '699', '699', '699', '849', '849', '649', '849', '849', '949', '849', '949', '499', '849', '949', '849', '949', '1149', '899', '1349', '1449']\n"
     ]
    }
   ],
   "source": [
    "price_table = '''\n",
    "iPhone (2007): 499 599\n",
    "iPhone 3G (2008): 599  699\n",
    "iPhone 3GS (2009): 599 699\n",
    "iPhone 4 (2010): 599   699\n",
    "iPhone 4S (2011): 649  849\n",
    "iPhone 5 (2012): 649   849\n",
    "iPhone 5c (2013): 549   649\n",
    "iPhone 5s (2013): 649  849\n",
    "iPhone 6 (2014): 649   849\n",
    "iPhone 6 Plus (2014): 749  949\n",
    "iPhone 6s (2015): 649  849\n",
    "iPhone 6s Plus (2015): 749 949\n",
    "iPhone SE (2016): 399   499\n",
    "iPhone 7 (2016): 649   849\n",
    "iPhone 7 Plus (2016): 769  949\n",
    "iPhone 8 (2017): 699   849\n",
    "iPhone 8 Plus (2017): 799  949\n",
    "iPhone X (2017): 999   1149\n",
    "iPhone Xr (2018): 749   899\n",
    "iPhone Xs (2018): 999   1349\n",
    "iPhone Xs Max (2018): 1099  1449\n",
    "'''\n",
    "\n",
    "price_table = price_table.strip().split('\\n')\n",
    "products = []\n",
    "price_min = []\n",
    "price_max = []\n",
    "for line in price_table:\n",
    "    prod, ps = line.split(':')\n",
    "    p_min, p_max = ps.strip().split()\n",
    "    products.append(prod)\n",
    "    price_min.append(p_min)\n",
    "    price_max.append(p_max)\n",
    "\n",
    "print(products,price_min,price_max)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 227,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"a69d32cbbc4441a6be4b8189f3b074ff\" style=\"width:800px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_a69d32cbbc4441a6be4b8189f3b074ff = echarts.init(document.getElementById('a69d32cbbc4441a6be4b8189f3b074ff'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_a69d32cbbc4441a6be4b8189f3b074ff = {\n",
       "    \"grid\": [\n",
       "        {\n",
       "            \"bottom\": \"25%\"\n",
       "        },\n",
       "        {\n",
       "            \"bottom\": \"25%\"\n",
       "        }\n",
       "    ],\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"boundaryGap\": true,\n",
       "            \"nameGap\": 25,\n",
       "            \"inverse\": false,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"type\": \"value\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                },\n",
       "                \"interval\": \"auto\",\n",
       "                \"margin\": 8,\n",
       "                \"rotate\": 0,\n",
       "                \"formatter\": \"{value} \"\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"boundaryGap\": true,\n",
       "            \"nameGap\": 25,\n",
       "            \"inverse\": false,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"data\": [\n",
       "                \"iPhone (2007)\",\n",
       "                \"iPhone 3G (2008)\",\n",
       "                \"iPhone 3GS (2009)\",\n",
       "                \"iPhone 4 (2010)\",\n",
       "                \"iPhone 4S (2011)\",\n",
       "                \"iPhone 5 (2012)\",\n",
       "                \"iPhone 5c (2013)\",\n",
       "                \"iPhone 5s (2013)\",\n",
       "                \"iPhone 6 (2014)\",\n",
       "                \"iPhone 6 Plus (2014)\",\n",
       "                \"iPhone 6s (2015)\",\n",
       "                \"iPhone 6s Plus (2015)\",\n",
       "                \"iPhone SE (2016)\",\n",
       "                \"iPhone 7 (2016)\",\n",
       "                \"iPhone 7 Plus (2016)\",\n",
       "                \"iPhone 8 (2017)\",\n",
       "                \"iPhone 8 Plus (2017)\",\n",
       "                \"iPhone X (2017)\",\n",
       "                \"iPhone Xr (2018)\",\n",
       "                \"iPhone Xs (2018)\",\n",
       "                \"iPhone Xs Max (2018)\"\n",
       "            ],\n",
       "            \"type\": \"category\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": false\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"axisLabel\": {\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                },\n",
       "                \"margin\": 8,\n",
       "                \"rotate\": 45,\n",
       "                \"interval\": 0\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"top\": \"auto\",\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            },\n",
       "            \"text\": \"iPhone\\u552e\\u4ef7\",\n",
       "            \"left\": \"auto\"\n",
       "        }\n",
       "    ],\n",
       "    \"series_id\": 3275894,\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"lineStyle\": {\n",
       "                \"normal\": {\n",
       "                    \"opacity\": 1,\n",
       "                    \"curveness\": 0,\n",
       "                    \"width\": 1,\n",
       "                    \"type\": \"solid\"\n",
       "                }\n",
       "            },\n",
       "            \"showSymbol\": true,\n",
       "            \"symbolSize\": 4,\n",
       "            \"symbol\": \"emptyCircle\",\n",
       "            \"smooth\": false,\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0.2\n",
       "            },\n",
       "            \"data\": [\n",
       "                [\n",
       "                    \"iPhone (2007)\",\n",
       "                    \"499\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 3G (2008)\",\n",
       "                    \"599\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 3GS (2009)\",\n",
       "                    \"599\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 4 (2010)\",\n",
       "                    \"599\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 4S (2011)\",\n",
       "                    \"649\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 5 (2012)\",\n",
       "                    \"649\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 5c (2013)\",\n",
       "                    \"549\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 5s (2013)\",\n",
       "                    \"649\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 6 (2014)\",\n",
       "                    \"649\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 6 Plus (2014)\",\n",
       "                    \"749\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 6s (2015)\",\n",
       "                    \"649\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 6s Plus (2015)\",\n",
       "                    \"749\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone SE (2016)\",\n",
       "                    \"399\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 7 (2016)\",\n",
       "                    \"649\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 7 Plus (2016)\",\n",
       "                    \"769\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 8 (2017)\",\n",
       "                    \"699\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 8 Plus (2017)\",\n",
       "                    \"799\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone X (2017)\",\n",
       "                    \"999\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone Xr (2018)\",\n",
       "                    \"749\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone Xs (2018)\",\n",
       "                    \"999\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone Xs Max (2018)\",\n",
       "                    \"1099\"\n",
       "                ]\n",
       "            ],\n",
       "            \"name\": \"\\u6700\\u4f4e\",\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"type\": \"line\",\n",
       "            \"step\": false,\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 3275894,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            }\n",
       "        },\n",
       "        {\n",
       "            \"lineStyle\": {\n",
       "                \"normal\": {\n",
       "                    \"opacity\": 1,\n",
       "                    \"curveness\": 0,\n",
       "                    \"width\": 1,\n",
       "                    \"type\": \"solid\"\n",
       "                }\n",
       "            },\n",
       "            \"showSymbol\": true,\n",
       "            \"symbolSize\": 4,\n",
       "            \"symbol\": \"emptyCircle\",\n",
       "            \"smooth\": false,\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0.2\n",
       "            },\n",
       "            \"data\": [\n",
       "                [\n",
       "                    \"iPhone (2007)\",\n",
       "                    \"599\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 3G (2008)\",\n",
       "                    \"699\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 3GS (2009)\",\n",
       "                    \"699\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 4 (2010)\",\n",
       "                    \"699\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 4S (2011)\",\n",
       "                    \"849\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 5 (2012)\",\n",
       "                    \"849\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 5c (2013)\",\n",
       "                    \"649\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 5s (2013)\",\n",
       "                    \"849\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 6 (2014)\",\n",
       "                    \"849\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 6 Plus (2014)\",\n",
       "                    \"949\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 6s (2015)\",\n",
       "                    \"849\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 6s Plus (2015)\",\n",
       "                    \"949\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone SE (2016)\",\n",
       "                    \"499\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 7 (2016)\",\n",
       "                    \"849\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 7 Plus (2016)\",\n",
       "                    \"949\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 8 (2017)\",\n",
       "                    \"849\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone 8 Plus (2017)\",\n",
       "                    \"949\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone X (2017)\",\n",
       "                    \"1149\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone Xr (2018)\",\n",
       "                    \"899\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone Xs (2018)\",\n",
       "                    \"1349\"\n",
       "                ],\n",
       "                [\n",
       "                    \"iPhone Xs Max (2018)\",\n",
       "                    \"1449\"\n",
       "                ]\n",
       "            ],\n",
       "            \"name\": \"\\u6700\\u9ad8\",\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"type\": \"line\",\n",
       "            \"step\": false,\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"seriesId\": 3275894,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"tooltip\": {\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"borderWidth\": 0,\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"trigger\": \"item\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        }\n",
       "    },\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u6700\\u4f4e\",\n",
       "                \"\\u6700\\u9ad8\"\n",
       "            ],\n",
       "            \"show\": true,\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            },\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"selectedMode\": \"multiple\"\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"dataView\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"\\u4e0b\\u8f7d\\u56fe\\u7247\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true\n",
       "            }\n",
       "        },\n",
       "        \"left\": \"95%\"\n",
       "    }\n",
       "};\n",
       "myChart_a69d32cbbc4441a6be4b8189f3b074ff.setOption(option_a69d32cbbc4441a6be4b8189f3b074ff);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.custom.grid.Grid at 0x11133c780>"
      ]
     },
     "execution_count": 227,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "line = Line('iPhone售价')\n",
    "line.add(\"最低\", products, price_min, is_fill=True, area_opacity=0.2)\n",
    "line.add(\"最高\", products, price_max, is_fill=True, area_opacity=0.2, xaxis_interval=0, xaxis_rotate=45)\n",
    "grid = Grid()\n",
    "grid.add(line, grid_bottom=\"25%\")\n",
    "grid"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
